Course: Tableau Training
Topic: Introduction to Tableau Data Connections
Learn more: JustAcademy Tableau Training | Register for a Tableau Course Demo
A data connection in Tableau is a link between Tableau and a data source. It allows Tableau to access, read, organize, and analyze data so users can create charts, reports, dashboards, and interactive visualizations.
Data can come from spreadsheets, text files, relational databases, cloud platforms, and other supported sources. After connecting, users can review the data, select tables, establish relationships, and begin building visualizations.
Imagine a retail company stores its sales information in an Excel file. By connecting Tableau to that file, an analyst can study total sales, profit, product performance, and regional trends through charts and dashboards.
A data source is the original location or system where data is stored. It may be a file, database, cloud service, or a published data source available through Tableau Server or Tableau Cloud.
| Data Source | Example | Typical Use |
|---|---|---|
| Spreadsheet | Microsoft Excel | Sales reports and business records |
| Text file | CSV or TSV | Exported records and survey data |
| Relational database | MySQL, PostgreSQL, SQL Server | Structured business information |
| Cloud data platform | Snowflake, Google BigQuery | Large-scale cloud analytics |
| Published data source | Tableau Server or Tableau Cloud | Sharing managed data with a team |
Note: Connector availability and connection options depend on the Tableau product, version, permissions, and data source configuration.
File-based sources store information in files on a computer or in an accessible storage location.
Example: Connect Tableau to an Excel file containing monthly sales figures and create a chart showing sales by month.
Database connections allow Tableau to access information stored in database systems. Depending on the connector, users may need to provide a server name, database name, authentication details, and other connection settings.
Example: A business analyst connects to a company sales database to examine transactions, customers, and products.
Cloud data connections let Tableau access data stored on supported cloud platforms or services. They may require sign-in, authentication, server details, or permission from an administrator.
A published data source is a data source made available on Tableau Server or Tableau Cloud. Authorized users can connect to it instead of creating a separate connection from scratch. This can help teams reuse centrally managed data and definitions.
Tableau commonly works with data through two important connection approaches: live connections and extracts. The available options depend on the source and Tableau product.
A live connection allows Tableau to query the underlying data source when analysis requires data. Results depend on the source system, network, query performance, and connector capabilities.
Advantages:
Limitations:
An extract is a saved snapshot of data stored in Tableau's extract format. It can support efficient analysis without querying the original source for every interaction. Extracts may need to be refreshed to include newer source data.
Advantages:
Limitations:
| Feature | Live Connection | Extract |
|---|---|---|
| Data access | Queries the underlying source | Uses a saved snapshot |
| Data freshness | Can reflect recent source changes when queried | Reflects data captured at the last refresh |
| Performance | Depends on source and network performance | Can be faster for some analyses |
| Source workload | Queries may add load to the source | Can reduce repeated queries to the source |
| Maintenance | Requires a working connection and suitable access | May require scheduled or manual refreshes |
| Best suited for | Analysis requiring recent source data | Analysis benefiting from a stored snapshot |
Follow these steps to connect Tableau to an Excel workbook.
Suppose an Excel workbook contains these columns: Order Date, Region, Category, Sales, and Profit. Once connected, Tableau can use them to build a monthly sales trend, regional sales comparison, and profit analysis.
A CSV file stores tabular data as text, with values commonly separated by commas.
Important: If the data appears in a single column or contains incorrect characters, check the file's delimiter, encoding, and formatting.
Connecting to a database usually requires the relevant connector and valid access credentials.
Example: A sales analyst connects to a SQL database and selects the Orders table to analyze order values by region and month.
Security tip: Use authorized credentials and follow your organization's rules for database access. Do not share passwords in workbooks, screenshots, or public files.
After connecting to a source, Tableau opens the Data Source page. This is where users review the connection and prepare the data structure for analysis.
A data source may contain more than one table. Tableau provides ways to work with related tables, depending on the data structure and connection type.
Relationships connect tables through matching fields while keeping their logical table structures separate. Tableau determines how to query related tables based on the fields used in a visualization.
Example: Connect an Orders table to a Customers table using Customer ID.
A join combines rows from two tables based on a matching condition. Common join types include inner, left, right, and full outer joins, subject to the connector and data model.
| Join Type | Basic Meaning |
|---|---|
| Inner Join | Returns rows with matching values in both tables. |
| Left Join | Returns all rows from the left table and matching rows from the right table. |
| Right Join | Returns all rows from the right table and matching rows from the left table. |
| Full Outer Join | Returns matching rows and unmatched rows from both tables. |
A union appends rows from one table to another when their structures are compatible. For example, January and February sales files can be combined into one table if their columns align appropriately.
Best practice: Check matching fields, data types, duplicate records, and row counts after combining tables.
After connecting to data, check that Tableau recognizes each field correctly. Incorrect data types can affect calculations, filters, sorting, and visualizations.
| Data Type | Example | Common Use |
|---|---|---|
| String | Product Name | Names, labels, and categories |
| Number (whole) | Quantity | Counts and whole-number values |
| Number (decimal) | Profit | Amounts and measurements with decimals |
| Date | 2026-01-15 | Dates and time-based analysis |
| Boolean | True or False | Logical values |
| Geographic | Country or City | Maps and location-based analysis |
| Problem | Possible Cause | Solution |
|---|---|---|
| File not found | The file was moved or renamed | Browse to the correct file location and reconnect. |
| Authentication failed | Invalid credentials or missing permissions | Verify credentials and request access if needed. |
| Unable to reach server | Network, server, or connection configuration issue | Check server availability, network access, and connection details. |
| Incorrect columns | Delimiter or file structure problem | Inspect the source file and confirm the delimiter and headers. |
| Wrong data type | Tableau inferred an unsuitable type | Review and correct the field data type. |
| Data appears outdated | An extract has not been refreshed | Refresh the extract if supported and verify the refresh status. |
| Slow workbook | Large data volume or slow source queries | Review filters, data model design, query performance, and whether an extract is appropriate. |
| Missing fields | Wrong table selected or source structure changed | Verify the selected table and refresh or review the connection. |
Objective: Connect Tableau to a sales dataset and create a basic sales visualization.
| Order Date | Region | Category | Sales | Profit |
|---|---|---|---|---|
| 2026-01-05 | West | Technology | 15000 | 3500 |
| 2026-01-12 | East | Furniture | 9000 | 1200 |
| 2026-02-03 | North | Office Supplies | 6000 | 900 |
| 2026-02-18 | South | Technology | 18000 | 4200 |
| 2026-03-08 | West | Furniture | 11000 | 1700 |
Expected learning: You should be able to connect a file, inspect its data, validate field types, and create basic visualizations.
A data connection links Tableau to a data source so that its information can be accessed and analyzed.
Depending on the product and available connectors, Tableau can connect to files, databases, cloud platforms, and published data sources.
A live connection queries the underlying source, while an extract uses a stored snapshot of the data that may need refreshing.
It is the workspace used to review connections, select tables, inspect data, and prepare the data structure before building visualizations.
A relationship links tables through common fields while preserving their logical table structures.
A join combines rows from tables based on a matching condition.
Possible reasons include incorrect credentials, missing permissions, unavailable servers, network problems, or incorrect file paths.
An extract refresh updates a stored Tableau extract with data from its source, subject to the source and refresh configuration.
Correct data types help Tableau interpret fields properly for calculations, sorting, filtering, and visualization.
It is a data source shared on Tableau Server or Tableau Cloud so authorized users can reuse a centrally managed connection.
Tableau data connections are the foundation of data analysis and visualization. By learning how to connect to files, databases, and other supported sources, inspect data, choose between live connections and extracts, and prepare tables correctly, learners can build more reliable reports and dashboards.
Practice with small datasets first, validate your data before creating charts, and choose connection settings according to data freshness, performance, and access requirements.
Explore the course: JustAcademy Tableau Training | Register for a Tableau Course Demo
